SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwlAreasExterioresPredio
AS
SELECT     dbo.u_f1_06_areasexteriores.Id, dbo.u_f1_06_areasexteriores.idCui, dbo.u_f1_06_areasexteriores.numIdentific, 
                      dbo.u_tp_terminacionpiso.descripcion AS TipoArea, dbo.u_tp_areas_exteriores.descripcion AS TerminacionPiso, 
                      dbo.u_tp_estado.descripcion AS Estado
FROM         dbo.u_f1_06_areasexteriores INNER JOIN
                      dbo.u_f1_00_varios ON dbo.u_f1_06_areasexteriores.idCui = dbo.u_f1_00_varios.idCui INNER JOIN
                      dbo.u_tp_areas_exteriores ON dbo.u_f1_06_areasexteriores.idTipoAreaExterior = dbo.u_tp_areas_exteriores.Id INNER JOIN
                      dbo.u_tp_terminacionpiso ON dbo.u_f1_06_areasexteriores.idTermPiso = dbo.u_tp_terminacionpiso.id INNER JOIN
                      dbo.u_tp_estado ON dbo.u_f1_06_areasexteriores.idEstado = dbo.u_tp_estado.Id
GO
GRANT SELECT ON  [dbo].[vwlAreasExterioresPredio] TO [Cenie]
GO
